Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	20
Number of observations	913595
Missing cells	1465
Missing cells (%)	< 0.1%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	175.1 MiB
Average record size in memory	201.0 B

Variable types

Numeric	14
DateTime	3
Categorical	3

Alerts

`breadth` is highly overall correlated with `draught` and 1 other fields	High correlation
`course_over_ground` is highly overall correlated with `true_heading`	High correlation
`destination` is highly overall correlated with `end_latitude` and 4 other fields	High correlation
`draught` is highly overall correlated with `breadth` and 1 other fields	High correlation
`end_latitude` is highly overall correlated with `destination` and 7 other fields	High correlation
`end_longitude` is highly overall correlated with `destination` and 7 other fields	High correlation
`end_port` is highly overall correlated with `destination` and 7 other fields	High correlation
`latitude` is highly overall correlated with `end_latitude` and 6 other fields	High correlation
`length` is highly overall correlated with `breadth` and 1 other fields	High correlation
`longitude` is highly overall correlated with `end_latitude` and 6 other fields	High correlation
`start_latitude` is highly overall correlated with `end_latitude` and 6 other fields	High correlation
`start_longitude` is highly overall correlated with `destination` and 7 other fields	High correlation
`start_port` is highly overall correlated with `destination` and 7 other fields	High correlation
`true_heading` is highly overall correlated with `course_over_ground`	High correlation
`destination` is highly imbalanced (55.3%)	Imbalance

Reproduction

Analysis started	2025-06-10 22:05:04.508589
Analysis finished	2025-06-10 22:05:56.347438
Duration	51.84 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

trip_id
Real number (ℝ)

Distinct	1126
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1125611.9

Minimum	5944
Maximum	2278147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	5944
5-th percentile	55365
Q1	473272
median	1170717
Q3	1669988
95-th percentile	2160044
Maximum	2278147
Range	2272203
Interquartile range (IQR)	1196716

Descriptive statistics

Standard deviation	673814.36
Coefficient of variation (CV)	0.59862048
Kurtosis	-1.2739622
Mean	1125611.9
Median Absolute Deviation (MAD)	546619
Skewness	-0.039517174
Sum	1.0283534 × 10¹²
Variance	4.5402579 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2183472	2609	0.3%
1669988	2362	0.3%
265994	2085	0.2%
1778056	2068	0.2%
2201111	2059	0.2%
1993462	2053	0.2%
1019076	2036	0.2%
2183480	2026	0.2%
624032	1994	0.2%
1677413	1989	0.2%
Other values (1116)	892314	97.7%

Value	Count	Frequency (%)
5944	1237	0.1%
10257	577	0.1%
19002	41	< 0.1%
19585	1646	0.2%
23834	1241	0.1%
24805	595	0.1%
25124	659	0.1%
28257	1280	0.1%
29139	1247	0.1%
29152	1296	0.1%

Value	Count	Frequency (%)
2278147	518	0.1%
2278140	588	0.1%
2278125	528	0.1%
2278114	574	0.1%
2278113	574	0.1%
2278085	522	0.1%
2278084	522	0.1%
2278083	522	0.1%
2278070	494	0.1%
2278069	494	0.1%

start_latitude
Real number (ℝ)

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.033007

Minimum	53.33
Maximum	54.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.52
Q1	53.58
median	54.36
Q3	54.36
95-th percentile	54.36
Maximum	54.54
Range	1.21
Interquartile range (IQR)	0.78

Descriptive statistics

Standard deviation	0.39140852
Coefficient of variation (CV)	0.0072438781
Kurtosis	-1.8378472
Mean	54.033007
Median Absolute Deviation (MAD)	0
Skewness	-0.3615352
Sum	49364285
Variance	0.15320063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
54.36	525478	57.5%
53.58	168718	18.5%
53.59	56719	6.2%
53.51	34008	3.7%
53.57	26593	2.9%
53.53	23437	2.6%
53.6	21983	2.4%
53.52	10380	1.1%
53.55	5686	0.6%
53.56	5650	0.6%
Other values (18)	34943	3.8%

Value	Count	Frequency (%)
53.33	3169	0.3%
53.34	2535	0.3%
53.5	1285	0.1%
53.51	34008	3.7%
53.52	10380	1.1%
53.53	23437	2.6%
53.54	1288	0.1%
53.55	5686	0.6%
53.56	5650	0.6%
53.57	26593	2.9%

Value	Count	Frequency (%)
54.54	3667	0.4%
54.49	552	0.1%
54.37	1257	0.1%
54.36	525478	57.5%
54.33	3161	0.3%
54.31	1158	0.1%
53.75	976	0.1%
53.74	530	0.1%
53.67	2150	0.2%
53.66	411	< 0.1%

start_longitude
Real number (ℝ)

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4652193

Minimum	8.14
Maximum	10.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	8.14
5-th percentile	8.5
Q1	8.52
median	10.14
Q3	10.14
95-th percentile	10.14
Maximum	10.34
Range	2.2
Interquartile range (IQR)	1.62

Descriptive statistics

Standard deviation	0.80564026
Coefficient of variation (CV)	0.085115858
Kurtosis	-1.8490887
Mean	9.4652193
Median Absolute Deviation (MAD)	0
Skewness	-0.36017706
Sum	8647377
Variance	0.64905624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
10.14	498283	54.5%
8.52	160444	17.6%
8.53	78601	8.6%
8.51	36432	4.0%
8.57	31343	3.4%
10.13	24011	2.6%
8.54	15226	1.7%
8.5	11982	1.3%
8.15	10964	1.2%
8.49	9062	1.0%
Other values (24)	37247	4.1%

Value	Count	Frequency (%)
8.14	485	0.1%
8.15	10964	1.2%
8.16	1297	0.1%
8.19	976	0.1%
8.22	530	0.1%
8.36	1078	0.1%
8.37	1072	0.1%
8.38	411	< 0.1%
8.39	984	0.1%
8.4	523	0.1%

Value	Count	Frequency (%)
10.34	552	0.1%
10.29	3667	0.4%
10.18	3188	0.3%
10.17	2933	0.3%
10.16	1485	0.2%
10.15	1154	0.1%
10.14	498283	54.5%
10.13	24011	2.6%
8.57	31343	3.4%
8.56	3146	0.3%

start_time
Date

Distinct	953
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 06:03:00+00:00
Maximum	2017-05-26 19:44:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

end_latitude
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.084077

Minimum	53.47
Maximum	54.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.47
5-th percentile	53.5
Q1	53.53
median	54.38
Q3	54.53
95-th percentile	54.54
Maximum	54.64
Range	1.17
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.47536535
Coefficient of variation (CV)	0.0087893772
Kurtosis	-1.8529172
Mean	54.084077
Median Absolute Deviation (MAD)	0.16
Skewness	-0.31327499
Sum	49410942
Variance	0.22597222
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
54.54	217507	23.8%
53.53	194398	21.3%
53.5	87533	9.6%
54.38	85200	9.3%
54.52	54379	6.0%
54.53	40516	4.4%
53.54	37790	4.1%
54.44	33365	3.7%
53.52	31820	3.5%
54.43	24028	2.6%
Other values (19)	107059	11.7%

Value	Count	Frequency (%)
53.47	1290	0.1%
53.48	677	0.1%
53.49	9439	1.0%
53.5	87533	9.6%
53.51	10829	1.2%
53.52	31820	3.5%
53.53	194398	21.3%
53.54	37790	4.1%
53.56	678	0.1%
53.61	2018	0.2%

Value	Count	Frequency (%)
54.64	1646	0.2%
54.59	740	0.1%
54.54	217507	23.8%
54.53	40516	4.4%
54.52	54379	6.0%
54.51	5163	0.6%
54.5	522	0.1%
54.47	1280	0.1%
54.46	7687	0.8%
54.45	8797	1.0%

end_longitude
Real number (ℝ)

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.995004

Minimum	9.5
Maximum	18.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	9.5
5-th percentile	9.9
Q1	9.93
median	18.5
Q3	18.6
95-th percentile	18.71
Maximum	18.92
Range	9.42
Interquartile range (IQR)	8.67

Descriptive statistics

Standard deviation	4.2753309
Coefficient of variation (CV)	0.28511702
Kurtosis	-1.8773597
Mean	14.995004
Median Absolute Deviation (MAD)	0.17
Skewness	-0.34812911
Sum	13699361
Variance	18.278454
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
18.51	115647	12.7%
18.5	101860	11.1%
9.91	100740	11.0%
9.93	76722	8.4%
9.9	60305	6.6%
18.65	45248	5.0%
9.95	44441	4.9%
18.66	44309	4.8%
18.67	37754	4.1%
9.82	27616	3.0%
Other values (37)	258953	28.3%

Value	Count	Frequency (%)
9.5	1189	0.1%
9.51	661	0.1%
9.54	1196	0.1%
9.55	178	< 0.1%
9.56	644	0.1%
9.73	678	0.1%
9.82	27616	3.0%
9.83	6963	0.8%
9.88	1221	0.1%
9.9	60305	6.6%

Value	Count	Frequency (%)
18.92	1646	0.2%
18.88	740	0.1%
18.83	7385	0.8%
18.82	11996	1.3%
18.81	4884	0.5%
18.75	1500	0.2%
18.72	3774	0.4%
18.71	27107	3.0%
18.7	7897	0.9%
18.68	3368	0.4%

end_time
Date

Distinct	943
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 14:36:00+00:00
Maximum	2017-05-27 22:11:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

start_port
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	892.5 KiB

KIEL	535273
BREMERHAVEN	378322

Length

Max length	11
Median length	4
Mean length	6.8987177
Min length	4

Characters and Unicode

Total characters	6302634
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	BREMERHAVEN
2nd row	BREMERHAVEN
3rd row	BREMERHAVEN
4th row	BREMERHAVEN
5th row	BREMERHAVEN

Common Values

Value	Count	Frequency (%)
KIEL	535273	58.6%
BREMERHAVEN	378322	41.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kiel	535273	58.6%
bremerhaven	378322	41.4%

Most occurring characters

Value	Count	Frequency (%)
E	1670239	26.5%
R	756644	12.0%
K	535273	8.5%
I	535273	8.5%
L	535273	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6302634	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	1670239	26.5%
R	756644	12.0%
K	535273	8.5%
I	535273	8.5%
L	535273	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6302634	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	1670239	26.5%
R	756644	12.0%
K	535273	8.5%
I	535273	8.5%
L	535273	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6302634	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	1670239	26.5%
R	756644	12.0%
K	535273	8.5%
I	535273	8.5%
L	535273	8.5%
B	378322	6.0%
M	378322	6.0%
H	378322	6.0%
A	378322	6.0%
V	378322	6.0%

end_port
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	892.5 KiB

GDYNIA	535273
HAMBURG	378322

Length

Max length	7
Median length	6
Mean length	6.4141025
Min length	6

Characters and Unicode

Total characters	5859892
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Common Values

Value	Count	Frequency (%)
GDYNIA	535273	58.6%
HAMBURG	378322	41.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gdynia	535273	58.6%
hamburg	378322	41.4%

Most occurring characters

Value	Count	Frequency (%)
G	913595	15.6%
A	913595	15.6%
D	535273	9.1%
Y	535273	9.1%
N	535273	9.1%
I	535273	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5859892	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	913595	15.6%
A	913595	15.6%
D	535273	9.1%
Y	535273	9.1%
N	535273	9.1%
I	535273	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5859892	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	913595	15.6%
A	913595	15.6%
D	535273	9.1%
Y	535273	9.1%
N	535273	9.1%
I	535273	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5859892	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	913595	15.6%
A	913595	15.6%
D	535273	9.1%
Y	535273	9.1%
N	535273	9.1%
I	535273	9.1%
H	378322	6.5%
M	378322	6.5%
B	378322	6.5%
U	378322	6.5%

time_stamp
Date

Distinct	414192
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Memory size	7.0 MiB

Minimum	2016-01-13 06:03:00+00:00
Maximum	2017-05-27 22:11:00+00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

ship_type
Real number (ℝ)

Distinct	10
Distinct (%)	< 0.1%
Missing	1397
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	72.273954

Minimum	69
Maximum	89
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	69
5-th percentile	70
Q1	70
median	71
Q3	71
95-th percentile	80
Maximum	89
Range	20
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	3.5283781
Coefficient of variation (CV)	0.048819498
Kurtosis	0.87815848
Mean	72.273954
Median Absolute Deviation (MAD)	1
Skewness	1.5950954
Sum	65928156
Variance	12.449452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
71	409205	44.8%
70	311891	34.1%
79	123826	13.6%
81	34540	3.8%
72	12889	1.4%
80	11035	1.2%
73	3629	0.4%
74	3441	0.4%
69	1158	0.1%
89	584	0.1%
(Missing)	1397	0.2%

Value	Count	Frequency (%)
69	1158	0.1%
70	311891	34.1%
71	409205	44.8%
72	12889	1.4%
73	3629	0.4%
74	3441	0.4%
79	123826	13.6%
80	11035	1.2%
81	34540	3.8%
89	584	0.1%

Value	Count	Frequency (%)
89	584	0.1%
81	34540	3.8%
80	11035	1.2%
79	123826	13.6%
74	3441	0.4%
73	3629	0.4%
72	12889	1.4%
71	409205	44.8%
70	311891	34.1%
69	1158	0.1%

length
Real number (ℝ)

High correlation

Distinct	98
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	128.58654

Minimum	45
Maximum	399
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	45
5-th percentile	74
Q1	89
median	134
Q3	154
95-th percentile	171
Maximum	399
Range	354
Interquartile range (IQR)	65

Descriptive statistics

Standard deviation	42.463217
Coefficient of variation (CV)	0.33023064
Kurtosis	6.8184036
Mean	128.58654
Median Absolute Deviation (MAD)	28
Skewness	1.4993322
Sum	1.1747602 × 10⁸
Variance	1803.1248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
151	89298	9.8%
134	77596	8.5%
88	61305	6.7%
155	58877	6.4%
125	47108	5.2%
168	40709	4.5%
82	34548	3.8%
79	34121	3.7%
154	32709	3.6%
68	31700	3.5%
Other values (88)	405624	44.4%

Value	Count	Frequency (%)
45	1771	0.2%
65	1648	0.2%
66	1522	0.2%
68	31700	3.5%
70	5482	0.6%
74	9892	1.1%
75	10113	1.1%
79	34121	3.7%
80	1617	0.2%
81	8660	0.9%

Value	Count	Frequency (%)
399	1716	0.2%
397	1153	0.1%
396	660	0.1%
300	1142	0.1%
299	537	0.1%
295	1252	0.1%
294	2171	0.2%
293	1214	0.1%
277	1629	0.2%
275	3297	0.4%

breadth
Real number (ℝ)

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.291348

Minimum	8
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	8
5-th percentile	12
Q1	13
median	22
Q3	24
95-th percentile	27
Maximum	60
Range	52
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.1613635
Coefficient of variation (CV)	0.30364486
Kurtosis	5.1807798
Mean	20.291348
Median Absolute Deviation (MAD)	3
Skewness	0.92568828
Sum	18538074
Variance	37.9624
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
22	138472	15.2%
23	111574	12.2%
12	106192	11.6%
24	101595	11.1%
13	95877	10.5%
25	67310	7.4%
26	50019	5.5%
18	42465	4.6%
19	38486	4.2%
27	26464	2.9%
Other values (24)	135141	14.8%

Value	Count	Frequency (%)
8	1771	0.2%
9	637	0.1%
10	3532	0.4%
11	24132	2.6%
12	106192	11.6%
13	95877	10.5%
14	13278	1.5%
15	14257	1.6%
16	12904	1.4%
17	1662	0.2%

Value	Count	Frequency (%)
60	1716	0.2%
59	660	0.1%
56	1153	0.1%
48	1142	0.1%
42	1071	0.1%
40	3919	0.4%
36	652	0.1%
35	564	0.1%
33	681	0.1%
32	13768	1.5%

draught
Real number (ℝ)

High correlation

Distinct	248
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.4860624

Minimum	0.1
Maximum	14
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0.1
5-th percentile	2.8
Q1	4.6
median	7.2
Q3	8.3
95-th percentile	9.3
Maximum	14
Range	13.9
Interquartile range (IQR)	3.7

Descriptive statistics

Standard deviation	2.187501
Coefficient of variation (CV)	0.33726179
Kurtosis	-1.0358573
Mean	6.4860624
Median Absolute Deviation (MAD)	1.6
Skewness	-0.29239943
Sum	5925634.2
Variance	4.7851608
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.8	46318	5.1%
3.2	31677	3.5%
8.3	24085	2.6%
7.9	17477	1.9%
7.7	17073	1.9%
8.4	15522	1.7%
8.1	15030	1.6%
8	14613	1.6%
3.8	14105	1.5%
9.2	14024	1.5%
Other values (238)	703671	77.0%

Value	Count	Frequency (%)
0.1	637	0.1%
1.93	1771	0.2%
2.3	1607	0.2%
2.4	1828	0.2%
2.5	1373	0.2%
2.6	7279	0.8%
2.63	41	< 0.1%
2.7	1782	0.2%
2.8	46318	5.1%
2.9	471	0.1%

Value	Count	Frequency (%)
14	15	< 0.1%
13.23	544	0.1%
11.7	645	0.1%
11.54	1071	0.1%
11.45	551	0.1%
11.4	1223	0.1%
11.24	691	0.1%
11.1	627	0.1%
11	368	< 0.1%
10.98	211	< 0.1%

latitude
Real number (ℝ)

High correlation

Distinct	273
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.287471

Minimum	53.33
Maximum	56.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.56
Q1	53.85
median	54.47
Q3	54.65
95-th percentile	54.89
Maximum	56.34
Range	3.01
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.45826776
Coefficient of variation (CV)	0.0084415014
Kurtosis	-1.0504964
Mean	54.287471
Median Absolute Deviation (MAD)	0.34
Skewness	-0.13312877
Sum	49596762
Variance	0.21000934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.87	28797	3.2%
54.53	23462	2.6%
54.41	20333	2.2%
53.84	20044	2.2%
53.98	19631	2.1%
54.56	17212	1.9%
53.54	17009	1.9%
53.86	16700	1.8%
54.74	16683	1.8%
54.57	16667	1.8%
Other values (263)	717057	78.5%

Value	Count	Frequency (%)
53.33	13	< 0.1%
53.34	40	< 0.1%
53.35	29	< 0.1%
53.36	26	< 0.1%
53.37	25	< 0.1%
53.38	27	< 0.1%
53.39	26	< 0.1%
53.4	23	< 0.1%
53.41	24	< 0.1%
53.42	26	< 0.1%

Value	Count	Frequency (%)
56.34	2	< 0.1%
56.33	4	< 0.1%
56.32	4	< 0.1%
56.31	3	< 0.1%
56.3	3	< 0.1%
56.29	12	< 0.1%
56.28	8	< 0.1%
56.27	5	< 0.1%
56.26	5	< 0.1%
56.25	6	< 0.1%

longitude
Real number (ℝ)

High correlation

Distinct	1285
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.995706

Minimum	2.32
Maximum	20.66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	2.32
5-th percentile	8.08
Q1	9.03
median	11.08
Q3	14.12
95-th percentile	18.8
Maximum	20.66
Range	18.34
Interquartile range (IQR)	5.09

Descriptive statistics

Standard deviation	3.5082389
Coefficient of variation (CV)	0.29245789
Kurtosis	-0.65372502
Mean	11.995706
Median Absolute Deviation (MAD)	2.4
Skewness	0.74749541
Sum	10959217
Variance	12.30774
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.51	4757	0.5%
8.52	4514	0.5%
8.12	4441	0.5%
9.93	4405	0.5%
8.11	4178	0.5%
9.9	4113	0.5%
9.5	4022	0.4%
8.51	3619	0.4%
8.15	3189	0.3%
9.39	3178	0.3%
Other values (1275)	873179	95.6%

Value	Count	Frequency (%)
2.32	1	< 0.1%
7.71	2	< 0.1%
7.72	45	< 0.1%
7.73	102	< 0.1%
7.74	99	< 0.1%
7.75	108	< 0.1%
7.76	83	< 0.1%
7.77	83	< 0.1%
7.78	81	< 0.1%
7.79	78	< 0.1%

Value	Count	Frequency (%)
20.66	1	< 0.1%
20.65	3	< 0.1%
20.64	2	< 0.1%
20.63	2	< 0.1%
20.62	3	< 0.1%
20.61	3	< 0.1%
20.6	2	< 0.1%
20.59	3	< 0.1%
20.58	3	< 0.1%
20.57	3	< 0.1%

speed_over_ground
Real number (ℝ)

Distinct	225
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.044391

Minimum	0.2
Maximum	22.6
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0.2
5-th percentile	6.5
Q1	9.8
median	11.9
Q3	14.6
95-th percentile	17.5
Maximum	22.6
Range	22.4
Interquartile range (IQR)	4.8

Descriptive statistics

Standard deviation	3.5389761
Coefficient of variation (CV)	0.29382773
Kurtosis	0.58274964
Mean	12.044391
Median Absolute Deviation (MAD)	2.4
Skewness	-0.42493849
Sum	11003696
Variance	12.524352
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.4	13193	1.4%
10.5	13133	1.4%
10.7	12783	1.4%
10.6	12764	1.4%
10.3	12519	1.4%
11	11598	1.3%
11.6	11505	1.3%
10.9	11485	1.3%
10.2	11480	1.3%
11.7	11383	1.2%
Other values (215)	791752	86.7%

Value	Count	Frequency (%)
0.2	442	< 0.1%
0.3	1617	0.2%
0.4	1337	0.1%
0.5	1054	0.1%
0.6	958	0.1%
0.7	814	0.1%
0.8	907	0.1%
0.9	843	0.1%
1	771	0.1%
1.1	738	0.1%

Value	Count	Frequency (%)
22.6	1	< 0.1%
22.5	1	< 0.1%
22.4	2	< 0.1%
22.3	1	< 0.1%
22.2	4	< 0.1%
22.1	4	< 0.1%
22	6	< 0.1%
21.9	5	< 0.1%
21.8	6	< 0.1%
21.7	12	< 0.1%

course_over_ground
Real number (ℝ)

High correlation

Distinct	3601
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	124.97899

Minimum	0
Maximum	360
Zeros	192
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	44
Q1	81.8
median	99.1
Q3	134
95-th percentile	312
Maximum	360
Range	360
Interquartile range (IQR)	52.2

Descriptive statistics

Standard deviation	76.465793
Coefficient of variation (CV)	0.61182916
Kurtosis	1.3315164
Mean	124.97899
Median Absolute Deviation (MAD)	21.5
Skewness	1.493163
Sum	1.1418018 × 10⁸
Variance	5847.0174
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
81	7475	0.8%
90	7334	0.8%
82	6782	0.7%
86	5624	0.6%
89	5526	0.6%
85	5337	0.6%
83	5150	0.6%
87	4993	0.5%
88	4950	0.5%
100	4679	0.5%
Other values (3591)	855745	93.7%

Value	Count	Frequency (%)
0	192	< 0.1%
0.1	290	< 0.1%
0.2	26	< 0.1%
0.3	26	< 0.1%
0.4	19	< 0.1%
0.5	37	< 0.1%
0.6	31	< 0.1%
0.7	29	< 0.1%
0.8	23	< 0.1%
0.9	44	< 0.1%

Value	Count	Frequency (%)
360	12	< 0.1%
359.9	43	< 0.1%
359.8	29	< 0.1%
359.7	16	< 0.1%
359.6	28	< 0.1%
359.5	28	< 0.1%
359.4	20	< 0.1%
359.3	31	< 0.1%
359.2	22	< 0.1%
359.1	40	< 0.1%

true_heading
Real number (ℝ)

High correlation

Distinct	361
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	130.71852

Minimum	0
Maximum	511
Zeros	565
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	7.0 MiB

Quantile statistics

Minimum	0
5-th percentile	45
Q1	82
median	99
Q3	136
95-th percentile	320
Maximum	511
Range	511
Interquartile range (IQR)	54

Descriptive statistics

Standard deviation	89.243751
Coefficient of variation (CV)	0.68271695
Kurtosis	3.8355445
Mean	130.71852
Median Absolute Deviation (MAD)	22
Skewness	1.9151708
Sum	1.1942379 × 10⁸
Variance	7964.4471
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	22874	2.5%
81	21301	2.3%
83	20883	2.3%
90	20022	2.2%
84	18941	2.1%
85	18885	2.1%
89	16462	1.8%
86	16055	1.8%
88	15375	1.7%
80	15244	1.7%
Other values (351)	727553	79.6%

Value	Count	Frequency (%)
0	565	0.1%
1	410	< 0.1%
2	349	< 0.1%
3	363	< 0.1%
4	262	< 0.1%
5	277	< 0.1%
6	271	< 0.1%
7	314	< 0.1%
8	282	< 0.1%
9	205	< 0.1%

Value	Count	Frequency (%)
511	12963	1.4%
359	399	< 0.1%
358	412	< 0.1%
357	337	< 0.1%
356	395	< 0.1%
355	465	0.1%
354	408	< 0.1%
353	295	< 0.1%
352	265	< 0.1%
351	223	< 0.1%

destination
Categorical

High correlation Imbalance

Distinct	16
Distinct (%)	< 0.1%
Missing	68
Missing (%)	< 0.1%
Memory size	54.9 MiB

DE.HAM	375027
PL.GDY	291375
PL.GDN	211838
LT.KLJ	23353
DE.STA	3787
Other values (11)	8147

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	5481162
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	DE.HAM
2nd row	DE.HAM
3rd row	DE.HAM
4th row	DE.HAM
5th row	DE.HAM

Common Values

Value	Count	Frequency (%)
DE.HAM	375027	41.0%
PL.GDY	291375	31.9%
PL.GDN	211838	23.2%
LT.KLJ	23353	2.6%
DE.STA	3787	0.4%
DE.KEL	3267	0.4%
DE.BRV	2439	0.3%
RU.KGD	1337	0.1%
SE.NOK	540	0.1%
SE.HAD	334	< 0.1%
Other values (6)	230	< 0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de.ham	375027	41.1%
pl.gdy	291375	31.9%
pl.gdn	211838	23.2%
lt.klj	23353	2.6%
de.sta	3787	0.4%
de.kel	3267	0.4%
de.brv	2439	0.3%
ru.kgd	1337	0.1%
se.nok	540	0.1%
se.had	334	< 0.1%
Other values (6)	230	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
.	913527	16.7%
D	889526	16.2%
L	553292	10.1%
G	504550	9.2%
P	503319	9.2%
E	388827	7.1%
A	379148	6.9%
H	375363	6.8%
M	375027	6.8%
Y	291375	5.3%
Other values (13)	307208	5.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5481162	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
.	913527	16.7%
D	889526	16.2%
L	553292	10.1%
G	504550	9.2%
P	503319	9.2%
E	388827	7.1%
A	379148	6.9%
H	375363	6.8%
M	375027	6.8%
Y	291375	5.3%
Other values (13)	307208	5.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5481162	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
.	913527	16.7%
D	889526	16.2%
L	553292	10.1%
G	504550	9.2%
P	503319	9.2%
E	388827	7.1%
A	379148	6.9%
H	375363	6.8%
M	375027	6.8%
Y	291375	5.3%
Other values (13)	307208	5.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5481162	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
.	913527	16.7%
D	889526	16.2%
L	553292	10.1%
G	504550	9.2%
P	503319	9.2%
E	388827	7.1%
A	379148	6.9%
H	375363	6.8%
M	375027	6.8%
Y	291375	5.3%
Other values (13)	307208	5.6%

	breadth	course_over_ground	destination	draught	end_latitude	end_longitude	end_port	latitude	length	longitude	ship_type	speed_over_ground	start_latitude	start_longitude	start_port	trip_id	true_heading
breadth	1.000	0.034	0.197	0.902	0.078	-0.272	0.406	-0.088	0.937	-0.097	0.302	0.432	-0.037	-0.183	0.406	-0.020	0.020
course_over_ground	0.034	1.000	0.167	0.004	-0.290	-0.290	0.460	-0.344	-0.005	-0.123	0.036	0.001	-0.323	-0.307	0.460	0.007	0.937
destination	0.197	0.167	1.000	0.182	0.698	0.995	0.995	0.354	0.230	0.327	0.170	0.136	0.448	0.704	0.995	0.160	0.155
draught	0.902	0.004	0.182	1.000	0.120	-0.179	0.266	-0.019	0.913	-0.028	0.330	0.424	0.067	-0.106	0.266	0.018	-0.003
end_latitude	0.078	-0.290	0.698	0.120	1.000	0.525	1.000	0.751	0.152	0.736	-0.096	-0.020	0.815	0.798	1.000	-0.025	-0.283
end_longitude	-0.272	-0.290	0.995	-0.179	0.525	1.000	1.000	0.719	-0.156	0.731	-0.037	-0.268	0.813	0.817	1.000	0.009	-0.262
end_port	0.406	0.460	0.995	0.266	1.000	1.000	1.000	1.000	0.398	0.919	0.229	0.246	1.000	1.000	1.000	0.263	0.397
latitude	-0.088	-0.344	0.354	-0.019	0.751	0.719	1.000	1.000	0.006	0.800	-0.071	-0.043	0.813	0.797	1.000	-0.013	-0.322
length	0.937	-0.005	0.230	0.913	0.152	-0.156	0.398	0.006	1.000	-0.001	0.274	0.427	0.099	-0.100	0.398	-0.049	-0.015
longitude	-0.097	-0.123	0.327	-0.028	0.736	0.731	0.919	0.800	-0.001	1.000	-0.075	-0.211	0.814	0.798	0.919	-0.013	-0.111
ship_type	0.302	0.036	0.170	0.330	-0.096	-0.037	0.229	-0.071	0.274	-0.075	1.000	0.189	-0.069	-0.088	0.229	0.146	0.036
speed_over_ground	0.432	0.001	0.136	0.424	-0.020	-0.268	0.246	-0.043	0.427	-0.211	0.189	1.000	-0.113	-0.191	0.246	-0.058	-0.025
start_latitude	-0.037	-0.323	0.448	0.067	0.815	0.813	1.000	0.813	0.099	0.814	-0.069	-0.113	1.000	0.842	1.000	-0.012	-0.304
start_longitude	-0.183	-0.307	0.704	-0.106	0.798	0.817	1.000	0.797	-0.100	0.798	-0.088	-0.191	0.842	1.000	1.000	-0.004	-0.286
start_port	0.406	0.460	0.995	0.266	1.000	1.000	1.000	1.000	0.398	0.919	0.229	0.246	1.000	1.000	1.000	0.263	0.397
trip_id	-0.020	0.007	0.160	0.018	-0.025	0.009	0.263	-0.013	-0.049	-0.013	0.146	-0.058	-0.012	-0.004	0.263	1.000	0.007
true_heading	0.020	0.937	0.155	-0.003	-0.283	-0.262	0.397	-0.322	-0.015	-0.111	0.036	-0.025	-0.304	-0.286	0.397	0.007	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	trip_id	start_latitude	start_longitude	start_time	end_latitude	end_longitude	end_time	start_port	end_port	time_stamp	ship_type	length	breadth	draught	latitude	longitude	speed_over_ground	course_over_ground	true_heading	destination
0	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:07:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	0.7	331.2	143	DE.HAM
1	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:10:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	1.6	315.3	117	DE.HAM
2	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:10:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	2.8	322.6	100	DE.HAM
3	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:12:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	2.8	286.3	74	DE.HAM
4	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:16:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	4.3	333.1	333	DE.HAM
5	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:17:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	5.2	334.0	333	DE.HAM
6	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:18:00+00:00	71.0	277.0	42.0	11.54	53.57	8.53	5.7	333.0	333	DE.HAM
7	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:19:00+00:00	71.0	277.0	42.0	11.54	53.57	8.52	6.3	333.0	333	DE.HAM
8	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:20:00+00:00	71.0	277.0	42.0	11.54	53.58	8.52	6.8	333.0	333	DE.HAM
9	39131	53.57	8.53	2016-01-24 08:06:00+00:00	53.53	9.9	2016-01-24 16:44:00+00:00	BREMERHAVEN	HAMBURG	2016-01-24 08:21:00+00:00	71.0	277.0	42.0	11.54	53.58	8.52	7.1	332.1	333	DE.HAM

	trip_id	start_latitude	start_longitude	start_time	end_latitude	end_longitude	end_time	start_port	end_port	time_stamp	ship_type	length	breadth	draught	latitude	longitude	speed_over_ground	course_over_ground	true_heading	destination
913585	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:02:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	222.0	215	PL.GDN
913586	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:01:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	221.6	215	PL.GDN
913587	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 14:00:00+00:00	70.0	89.0	13.0	4.0	54.50	18.74	7.2	221.5	215	PL.GDN
913588	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:59:00+00:00	70.0	89.0	13.0	4.0	54.50	18.75	7.2	221.2	215	PL.GDN
913589	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:58:00+00:00	70.0	89.0	13.0	4.0	54.50	18.75	7.2	220.8	215	PL.GDN
913590	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:57:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	221.0	215	PL.GDN
913591	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:56:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	221.9	215	PL.GDN
913592	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:55:00+00:00	70.0	89.0	13.0	4.0	54.51	18.75	7.2	222.1	215	PL.GDN
913593	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:54:00+00:00	70.0	89.0	13.0	4.0	54.51	18.76	7.2	221.2	215	PL.GDN
913594	2204049	54.36	10.14	2017-04-03 07:54:00+00:00	54.38	18.66	2017-04-04 15:28:00+00:00	KIEL	GDYNIA	2017-04-04 13:53:00+00:00	70.0	89.0	13.0	4.0	54.51	18.76	7.2	221.0	214	PL.GDN

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample